Percent sign instead of space (or tab) in the "line of file"

Dear BigFix Masters!
I am trying to display the content of the file in the analysis (3 numbers separated by a white space).

== On the linux host:
Looks great when I cat the file

[user@host ~]$ cat "/proc/sys/net/ipv4/tcp_mem"
1139520 1519360 2279040
[user@host ~]$

== In qna
I get %09 instead of the white space :frowning:
Q: line 1 of file "/proc/sys/net/ipv4/tcp_mem"
A: 1139520%091519360%092279040
T: 122

Q: line 1 of file β€œ/proc/sys/net/ipv4/tcp_mem” as string
A: 1139520%091519360%092279040
T: 120

== On the Manager Console
All 3 numbers are melted together, the worst way to display it :frowning:
113952015193602279040

Thanks for any suggestions,
Aleksandr

1 Like

%09 is a tab, so the data is tab-delimited which won’t display properly in the console. You can substitute spaces (or any other delimiter) with something like:

concatenation " " of substrings separated by "%09" of line 1 of file "/proc/sys/net/ipv4/tcp_mem"
2 Likes

Steve,
Thank you!

I ended up doing something very similar to what you are suggesting. My solution seems to be working although it is not elegant at all :frowning: (your solution is shorter and easier to read).

[users@host tda-dba-scripts-postgres]$ cat "/proc/sys/net/ipv4/tcp_mem"
753408 1004544 1506816
[user@host tda-dba-scripts-postgres]$

Looks like part1%09part2%09part3 to BigFix.

Parsing :
concatenations of (preceding text of first β€œ%09” of line 1 of file β€œ/proc/sys/net/ipv4/tcp_mem” & " " & preceding text of first β€œ%09” of following text of first β€œ%09” of line 1 of file β€œ/proc/sys/net/ipv4/tcp_mem” & " " & following text of first β€œ%09” of following text of first β€œ%09” of line 1 of file β€œ/proc/sys/net/ipv4/tcp_mem” )

Thank you,
Aleksandr

1 Like