topic Re: Insert symbol into string every x character? in App Development

Insert symbol into string every x character?

DevonB1 — Mon, 20 Dec 2021 21:02:46 GMT

I'm pretty new to Qlik Sense and just figuring things out. Would take this question to my mentor but he's been sidelined by a massive project, so I'm on my own for the time being.

What I'm dealing with is an app which loads numerous CSV's. Each of these has a computer MAC address field which is listed in the format AABBCCDDEEFF from the CSV source. What I'm wanting to do is to insert a "-" every 2 characters in order to make the MAC's display as AA-BB-CC-DD-EE-FF. More than looking nicer, this will let them interface with our backend DHCP system.

It does't matter if this happens at the data load phase or if I'm completely missing a way to make the front end do this for me in the tables. Just so long as I end up with a table that is correctly hyphenated for the MAC field.

Thank you ahead of time for any help with this. I greatly appreciate the assist.

Re: Insert symbol into string every x character?

MayilVahanan — Thu, 11 Mar 2021 08:37:34 GMT

HI @DevonB1

May be try like below

Load *, Left(MAC,2)&'-'&Mid(MAC,3,2)&'-'&Mid(MAC,5,2)&'-'&Mid(MAC,7,2)&'-'&Mid(MAC,9,2)&'-'&Right(MAC,2) as MAC1 Inline
[
MAC
AABBCCDDEEFF
];

MAC1 satisfy ur requirement

Re: Insert symbol into string every x character?

Or — Thu, 11 Mar 2021 09:02:45 GMT

I just answered this one a few days ago... this looks like a direct copy of that question, just from a different user...

https://community.qlik.com/t5/Qlik-Sense-App-Development/Insert-symbol-into-string-every-x-character/m-p/1789368#M61668

Re: Insert symbol into string every x character?

Mapuna — Tue, 20 Dec 2022 11:55:06 GMT

any way to make this dynamic?