1 2 Previous Next 17 Replies Latest reply on Nov 25, 2019 4:48 AM by Sinisa Mikor

How to remove the inline character to replace with blank.

Rakesh Rajasekar Nov 12, 2019 10:27 AM

Share This:

Dear ,

Can you tell me how to replace the inline word to be single word,Below value contain many spaces " "

APPNAME=srv_Interface&PRGNAME=XPI_HandleXMLMessage&DATA=PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4gPE1lc3NhZ2U%2B IDxIZWFkZXI%2BIDxQYXJ0bmVyPkVYMDYyPC9QYXJ0bmVyPiA8VXNlcm5hbWU%2BU2No bml0dHN0ZWxsZV90ZWxlZm9uaWNhPC9Vc2VybmFtZT4gPFBhc3N3b3JkPmlyZ2Vu ZHdhcyA8L1Bhc3N3b3JkPiA8VHlwZT5TdGF0dXNVcGRhdGU8L1R5cGU%2BIDxTdWJU eXBlPlVwZGF0ZTwvU3ViVHlwZT4gPENyZWF0ZWQ%2BMjAxOTExMTIxNzAxNTY8L0Ny ZWF0ZWQ%2BIDwvSGVhZGVyPiA8Q3VzdG9tZXJTdGF0dXNVcGRhdGU%2BIDxUaWNrZXRu dW1tZXJGST4yMDI5MjUwMDwvVGlja2V0bnVtbWVyRkk%2BIDxUaWNrZXRudW1tZXJU ZWxlZm9uaWNhPlRBUzAwMDAwMjE2NjA3ODwvVGlja2V0bnVtbWVyVGVsZWZvbmlj YT4gPFN0YXR1cz5Xb3JrIEluIFByb2dyZXNzPC9TdGF0dXM%2BIDxTdGF0dXNSZWFz b24%2BPC9TdGF0dXNSZWFzb24%2BIDxUZXh0PioqKlp3aXNjaGVubWVsZHVuZyoqKiBk ZXIgVGVjaG5pa2VyIHVuc2VyZXMgRGllbnN0bGVpc3RlcnMgYmVmaW5kZXQgc2lj aCBha3R1ZWxsIHZvciBPcnQgdW0gZGllIEhhcmR3YXJlIHp1IHRhdXNjaGVuPC9U ZXh0PiA8L0N1c3RvbWVyU3RhdHVzVXBkYXRlPiA8L01lc3NhZ2U%2BICANCg%3D%3D

I have tried below Set field action,

REPLACE($zTMP_Notes$, "

", "")

Any leads please

Thanks,

1. Re: How to remove the inline character to replace with blank.

rodrigo barcat Nov 12, 2019 10:34 AM (in response to Rakesh Rajasekar)

I paste your APPNAME on my text editor and it has just one line. You want to replace which character?
This one marked below? the blank space?
Like Show 0 Likes(0)

Actions
2. Re: How to remove the inline character to replace with blank.

Rakesh Rajasekar Nov 13, 2019 4:43 AM (in response to rodrigo barcat)

Hi Rodrigo,
If you copy the Appname to notedpad++ you will be see many spaces.
text editor dosent show.
I just want to what kind of space is it ?

the spaces are exactly in the end of the each line which is in green color.

ZWxlZm9uaWNhPlRBUzAwMDAwMjE2NjA3ODwvVGlja2V0bnVtbWVyVGVsZWZvbmlj

Thanks,
Rakesh
Like Show 0 Likes(0)

Actions
3. Re: How to remove the inline character to replace with blank.

rodrigo barcat Nov 13, 2019 4:49 AM (in response to Rakesh Rajasekar)

give me a minute....up the vm to simulate it here.
Like Show 0 Likes(0)

Actions
4. Re: How to remove the inline character to replace with blank.

rodrigo barcat Nov 13, 2019 6:12 AM (in response to Rakesh Rajasekar)

Hi, Rakesh Rajasekar

Take a look into screenshot below, this is the replace that you want?

If yes, I created an active link and excuted it on a button.

This active link set field from Field A to Field B with replace REPLACE($barcat_data2Replace$, " ", "")

And my form is designed as below:

It helps you?
1 of 1 people found this helpful
Like Show 2 Likes(2)

Actions
5. Re: How to remove the inline character to replace with blank.

Mohammed Gharaibeh Nov 13, 2019 7:18 AM (in response to Rakesh Rajasekar)

usually i use online sites for such action if i have a fixed text:
https://html-cleaner.com/features/remove-html-inline-styles/

but if the text is a value in a field then i guess what rodrigo barcat did should work with you.
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
6. Re: How to remove the inline character to replace with blank.

Rakesh Rajasekar Nov 14, 2019 4:45 AM (in response to rodrigo barcat)

Thanks Rodrigo,
am able to remove the inline using a SQL action,But am not able to remove the space in the end of the file,

I tried RTRIM also replace function and no luck.

APPNAME=srv_Interface&PRGNAME=XPI_HandleXMLMessage&DATA=PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4gPE1lc3NhZ2U%2BIDxIZWFkZXI%2BIDxQYXJ0bmVyPkVYMDYyPC9QYXJ0bmVyPiA8VXNlcm5hbWU%2BU2Nobml0dHN0ZWxsZV90ZWxlZm9uaWNhPC9Vc2VybmFtZT4gPFBhc3N3b3JkPmlyZ2VuZHdhcyA8L1Bhc3N3b3JkPiA8VHlwZT5TdGF0dXNVcGRhdGU8L1R5cGU%2BIDxTdWJUeXBlPlVwZGF0ZTwvU3ViVHlwZT4gPENyZWF0ZWQ%2BMjAxOTExMTQxMTQzNTY8L0NyZWF0ZWQ%2BIDwvSGVhZGVyPiA8Q3VzdG9tZXJTdGF0dXNVcGRhdGU%2BIDxUaWNrZXRudW1tZXJGST4yMDE3OTA4NzwvVGlja2V0bnVtbWVyRkk%2BIDxUaWNrZXRudW1tZXJUZWxlZm9uaWNhPlRBUzAwMDAwMjE0MjQ0NjwvVGlja2V0bnVtbWVyVGVsZWZvbmljYT4gPFN0YXR1cz5QZW5kaW5nPC9TdGF0dXM%2BIDxTdGF0dXNSZWFzb24%2BVW5kZXIgVmVyaWZpY2F0aW9uPC9TdGF0dXNSZWFzb24%2BIDwvQ3VzdG9tZXJTdGF0dXNVcGRhdGU%2BIDwvTWVzc2FnZT4gIA0K
Like Show 0 Likes(0)

Actions
7. Re: How to remove the inline character to replace with blank.

rodrigo barcat Nov 14, 2019 5:41 AM (in response to Rakesh Rajasekar)

No problem, but which method you want to use?

sql (share it with us) or setfield? take care when you use sql actions (on set field or direct sql), you need sure that your databases have the same table ID, Field Ids
Like Show 0 Likes(0)

Actions
8. Re: How to remove the inline character to replace with blank.

Rakesh Rajasekar Nov 14, 2019 6:04 AM (in response to rodrigo barcat)

SQL on set field :
SELECT REGEXP_REPLACE('$Field$', '[' || CHR (1) || '-' || CHR (32) || ']','') FROM DUAL

After that I tried to remove the inline space in End
GF0dXM%2BIDxTdGF0dXNSZWFzb24%2BVW5kZ
cGRhdGU%2BIDwvTWVzc2FnZT4gIA0K{space}{Space}
{inline}

I want remove or replace,

cGRhdGU%2BIDwvTWVzc2FnZT4gIA0K{space}{Space}
{inline}
to

cGRhdGU%2BIDwvTWVzc2FnZT4gIA0K

???

Thanks,
Rakesh
Like Show 0 Likes(0)

Actions
9. Re: How to remove the inline character to replace with blank.

rodrigo barcat Nov 14, 2019 6:56 AM (in response to Rakesh Rajasekar)

I am not using oracle on my VM, so I believe the function will be different.
I will be simpler (even because it works) and use replace on the Remedy object itself. You can create the function with Remedy objects and then look at the SQL log to see how it was executed, and rewrite in SQL language.

I will just do it this way because I can not test with an oracle database now.

I used in my function LTRIM and RTRIM as you can see on screenshot below.

011
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
10. Re: How to remove the inline character to replace with blank.

Rakesh Rajasekar Nov 14, 2019 8:51 AM (in response to rodrigo barcat)

If you can see in the last there is two space and below line.

I tried with your code it is not helping on my case.

Am setting the field using set field action and then via process am creating a .txt file to pass to interface.
Like Show 0 Likes(0)

Actions
11. Re: How to remove the inline character to replace with blank.

rodrigo barcat Nov 14, 2019 9:01 AM (in response to Rakesh Rajasekar)

uncheck your Broken Rows in Notepad

When it is checked my notepad is same yours.

Without broken rows

And after did the change on your active link, please run a flush cache on your midtier.

On my side, the file has no more black spaces and no more space in the last char.
Like Show 0 Likes(0)

Actions
12. Re: How to remove the inline character to replace with blank.

Sinisa Mikor Nov 14, 2019 10:24 AM (in response to rodrigo barcat)

Interesting naming convention...
Like Show 0 Likes(0)

Actions
13. Re: How to remove the inline character to replace with blank.

rodrigo barcat Nov 14, 2019 10:45 AM (in response to Sinisa Mikor)

aushuahsuahsuah for communities, on my VM, I do not use convention....I always write anything to know which post the object is for. The underline is only for the object to be at the beginning and barcat mmm I don't know, just because it's mine. aushuhsauhasuhasuh

for customers I create patterns, objects (forms, actl, fltr ...)

btw, what convention caught your eye?
Like Show 0 Likes(0)

Actions
14. Re: How to remove the inline character to replace with blank.

Sinisa Mikor Nov 14, 2019 1:23 PM (in response to rodrigo barcat)

"aushuahsuahsuah", of course. You may be a musician in your free time, but you probably don't think of variables as your children the same way songwriters think about their songs and thus pass them your (sur)name.
Like Show 0 Likes(0)

Actions