Spliting a string

Help
1

Can someone help in splitting a string (shampoo history390/mo - Rs4.83 - 0.05)

excepected output should be as

shampoohistory 390/mo rs4.83 0.05(actually i want to put in 4 columns)

2

Welcome @Karthik_Kulkarni,
Its tough to do if it is jumbled like this there should be some repeated delimiters.
Cheers.
Vashisht.

1 Like
3

@Karthik_Kulkarni,

If all the strrings is in the format you mentioned above. Please check attached code works for you.Sampoo.xaml (10.4 KB)

4

@Karthik_Kulkarni
You can use replace method of string to replace - with " "

Thanks

1 Like
5

thanks all for helping me.

1 Like
6

Your issue resolved? @Karthik_Kulkarni.
If yes please mark it as solution and close the thread.
If any issue ping me.
Cheers.
Vashisht.

7

Hi Vashisht,

I tried but id didn’t get the exact output , i will tell how my input is

Below is my input in excel and this should be done in spitted in four columns

prod_name
shampoo history1,300/mo - Rs38.65 - 0.09
shampoo origin880/mo - Rs20.01 - 0.14
shampoo brands14,800/mo - Rs44.17 - 0.98
best shampoo49,500/mo - Rs68.32 - 1
shampoo amazon2,900/mo - Rs26.91 - 1
tresemme shampoo74,000/mo - Rs11.73 - 1
shampoo price880/mo - Rs24.84 - 1
dove shampoo49,500/mo - Rs16.56 - 1

expected output in 4 different columns

shampoo history 1300/month rs38.65 0.09

Thanks and regards

kulkarni karthik

8

Hi @Karthik_Kulkarni,
You are getting everything in one column?

9

Yes Vashisht,

I am getting in one column ,I want to be done on 4 columns.

10

Hi @Karthik_Kulkarni
Please find the attached flow
BlankProcess1.zip (12.1 KB)

11

Try by separating them with comma

12

Hi @Karthik_Kulkarni
Please find the attached flow
BlankProcess1.zip (19.4 KB)

13

Hi Sandeep,

I just need to split GL* as I only need to use GL,
so how to split it such that I get only GL and not the ast. symbol.

2 Likes
14

@kartik_sareen

use this

variable1.Substring(variable1.IndexOf(“*”)- Convert.ToInt32(variable1.Length-1),2).ToString

Where variable1=GL*

Thanks

3 Likes
15

Thanks a lot Sandeep…it worked …

2 Likes