Wanted to split and create two new columns only numeric data(lower_limit and upper_limit)

[Meenaks]

Spoiler

[binuacs]

@Meenaks Can you provide more information?

[Meenaks]

Hi ,

I have column "VAP > 0.00 and 2500" , wanted to split the column and create two new columns as Lower_limit '0.00' and upper_limit '2500'.

Need to extract only numeric values and create columns.

[Meenaks]

"VAP > 25000 and <=10000" this is the format of the data, Wanted to get only numeric value as '25000' and '10000'

[Meenaks]

Want to remove the leading spaces and split the data.

Getting leading space issue, wanted to split the values into two columns

0.00 2500

2500 10000    - split as 2 columns 

Lower_limit      upper limit

0.00                  2500

2500                 10000

[binuacs]

@Meenaks have you tried the text-column tool to split the values?

[binuacs]

@Meenaks