topic Replacing field or table content in App Development

Replacing field or table content

leo88 — Fri, 15 Nov 2024 23:06:29 GMT

Hey guys,
I would like you to help me with a script. I need to create a column by replacing the textual content from another existing column, for example:

Coke 2L ---> 2L
Sugar 1KG ---> 1KG
Flour 5KG ---> 5KG
.... 
Can you guide me how to implement this? I believe I have to replace the letters until I get the goal, but I don't know how to start. Thanks.

Re: Replacing field or table content

Vegar — Wed, 16 Mar 2022 21:29:55 GMT

You could try to use subfield() for this.

Subfield ([YourStringField], ' ', -1)

Re: Replacing field or table content

leo88 — Wed, 16 Mar 2022 22:35:11 GMT

ok, but sometimes the field content can be complex or open, and I still want to extract the unit correctly.
 
I think of creating a routine that can read a part of the content and transform it into what I want, for example:
Coke (2 L) or Coke (2 L)iters ---> 2L
Sugar (5 KG) or Sugar (5 K)ilos ---> 5KG

thanks

Re: Replacing field or table content

leo88 — Sat, 19 Mar 2022 20:23:19 GMT

Hello Guys,

I am trying to use the replace function, but I realized that Qlikview can implement it just 100 times (ie. Replace(Replace( text, 'A', 'a'), 'B', 'b')....., 'ZZZ', 'zzz'). I need to use more than 200 replaces, can somebody tell me a way to do it?Thanks

Re: Replacing field or table content

Vegar — Sun, 20 Mar 2022 12:09:36 GMT

Take a look at the MapSubstring() function. It might be a good fit for your scenario.