Help with splitting a string into 50 character column string

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.

Regex

Parse

Preparation

Accepted answers

@anshumannc adjust the regex formula like below

All comments

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

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

Can you provide the desired outcome?

Hi Kim,

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

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

Screenshot 2023-05-23 155827.png

@anshumannc adjust the regex formula like below

OMG that worked. Thank you so much.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703