split text

[polugopi]

Hi All,
I have a task which is related to split text.
my input data is look like below :
1.Customer Invoice
2.Customer Address
3.Order Quantity
4.Order Status

Expected out put :
1.CI
2.CA
3.OQ
4.OS
Here i am confusing how to work with trim , in string and length functions.
Any one please share best solution.

 

[sivagelli]

Use Calc stage with expression-

Left("Customer Invoice", 1) & Mid("Customer Invoice", InStr("Customer Invoice"," ")+1,1)

This will result in "CI"

 

[polugopi]

Use Calc stage with expression-

Left("Customer Invoice", 1) & Mid("Customer Invoice", InStr("Customer Invoice"," ")+1,1)

This will result in "CI"

Logic is working fine.Thanks sivagelli.

 

[VJR]

Hi All,
I have a task which is related to split text.
my input data is look like below :
1.Customer Invoice
2.Customer Address
3.Order Quantity
4.Order Status

Expected out put :
1.CI
2.CA
3.OQ
4.OS
Here i am confusing how to work with trim , in string and length functions.
Any one please share best solution.

A simpler approach for you would be to use the String functions and get the first character from the left. You can use it depending on how your inputs are.

Alongside, if you are unaware of the length of the Input string you could do as below.
This is the Process diagram. Refer the Input and FinalResult data items.
View attachment 1542978049085.png

Split Text Input parameters:
View attachment 1542978196566.png

The output parameter of the above action is the Split Values collection with a Text column called 'Split'.

Calc stage:
View attachment 1542978258583.png

 

[polugopi]

A simpler approach for you would be to use the String functions and get the first character from the left. You can use it depending on how your inputs are.

Alongside, if you are unaware of the length of the Input string you could do as below.
This is the Process diagram. Refer the Input and FinalResult data items.
View attachment 2604

Split Text Input parameters:
View attachment 2605

The output parameter of the above action is the Split Values collection with a Text column called 'Split'.

Calc stage:
View attachment 2606

could you please share the data of input data item

 

[VJR]

could you please share the data of input data item

The data can be any text you want as shown in the Input data item of the first screenshot.