Spliting a string

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)

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

1 Like


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

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


1 Like

thanks all for helping me.

1 Like

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

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

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

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

Yes Vashisht,

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

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

Try by separating them with comma

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

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.



use this

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

Where variable1=GL*



Thanks a lot Sandeep…it worked …