topic Re: Splitting Text in GDL in GDL

Splitting Text in GDL

JeffH — Thu, 26 Sep 2024 11:50:41 GMT

We have our wall types all listed out like this in our composite list

- A _ Wall: MStud 6" Ins, Gyp.

In GDL, how would I strip out everything right of the "-" and then Left of the "_"

The end result needs to be " A ".

I am struggling to get the "WALL_COMPS_NAME" to work this way.

Any help would be greatly appreciated.

Re: Splitting Text in GDL

Yves — Mon, 11 Sep 2023 13:36:54 GMT

Hello,

With this function …

STRSUB (string_expression, start_position, characters_number)

Re: Splitting Text in GDL

JeffH — Mon, 11 Sep 2023 18:34:06 GMT

the number is the part that won't work I believe. (We have a wall tag that is set up with exactly this method, that has been brushed aside for its limitations.)

sometimes we have a wall that is wall "A" to 8' , and wall type "D" above.

- A / D _Wall: MStud 6" Ins, Gyp.

"A / D" won't show correctly if I have this scripted to read the first 2 or 3 characters. Id simply end up with "A /"

That is why I am trying to do a split to read everything between "-" & "_"

I have it working in properties & Classifications

But can't rely on calling that Unique ID for the property, because we have a few templates, so not every projects will have the same unique ID for the property that would be coded.

Re: Splitting Text in GDL

DGSketcher — Mon, 11 Sep 2023 21:27:13 GMT

Try the GDL function STRSTR to establish the position of "-" & "_", then apply those values to STRSUB as suggested by @Yves

Re: Splitting Text in GDL

AllanP — Sun, 17 Sep 2023 16:57:18 GMT

if strstr(WALL_COMPS_NAME,"-") > 0 and strstr(WALL_COMPS_NAME,"_")>0 then Start_num_pos = strstr(WALL_COMPS_NAME,"-") !!!!Postion in characters of first - character End_num_pos = strstr(WALL_COMPS_NAME,"_") !!!!Postion in characters of first _ character new_text_ = strsub(WALL_COMPS_NAME,Start_num_pos+1,End_num_pos-Start_num_pos-1) !!!!!!!!Makes new string from first character after - to character before _ endif

this works in AC18, AC22 and AC25

I hope this will help

Re: Splitting Text in GDL

Lingwisyer — Tue, 12 Sep 2023 01:52:17 GMT

string = Bar_Scale1 len = STRLEN (string) iDotPos = STRSTR (string, ":") v1 = STRSUB (string, iDotPos + 1, 6) v2 = SPLIT (v1, "%n", vl)

That is from my scale bar object.

Re: Splitting Text in GDL

JeffH — Tue, 12 Sep 2023 18:22:48 GMT

This is the solution we were after.

Thanks!!!!

Thank you all for your help in this matter.