Help with splitting a string into 50 character column string

[anshumannc]

Hi, 

I am trying to split the following string "ENTERAL FORMULA, NUTRITIONALLY COMPLETE, HYDROLYZED PROTEINS (AMINO ACIDS AND PEPTIDE CHAIN), INCLUDES FATS, CARBOHYDRATES, VITAMINS AND MINERALS, MAY INCLUDE FIBER, ADMINISTERED THROUGH AN ENTERAL FEEDING TUBE, 100 CALORIES = 1 UNIT" into size 50char columns. However, regex keeps stripping off characters from the string. 

[KimLamNg]

Not sure I understand your problem correctly but sounds like you should select Split to Columns (not Rows).

[anshumannc]

Hey thanks for the reply. The problem is the string is being truncated. Even when i split to columns. 

[KimLamNg]

Can you provide the desired outcome? 

[anshumannc]

Hi Kim, 

The desired outcome should be that string split into multiple columns wiht character length of 50. example 

[nagakavyasri]

I see that the string is split into multiple columns with 50 character, is this not what you are looking for?

[binuacs · Accepted solution]

@anshumannc adjust the regex formula like below

[anshumannc]

OMG that worked. Thank you so much.