-
1. Re: How to remove the inline character to replace with blank.
rodrigo barcatNov 12, 2019 10:34 AM (in response to Rakesh Rajasekar)
-
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
-
3. Re: How to remove the inline character to replace with blank.
rodrigo barcatNov 13, 2019 4:49 AM (in response to Rakesh Rajasekar)
give me a minute....up the vm to simulate it here.
-
4. Re: How to remove the inline character to replace with blank.
rodrigo barcatNov 13, 2019 6:12 AM (in response to Rakesh Rajasekar)
1 of 1 people found this helpfulHi, 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?
-
5. Re: How to remove the inline character to replace with blank.
Mohammed GharaibehNov 13, 2019 7:18 AM (in response to Rakesh Rajasekar)
1 of 1 people found this helpfulusually 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.
-
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
-
7. Re: How to remove the inline character to replace with blank.
rodrigo barcatNov 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
-
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
-
9. Re: How to remove the inline character to replace with blank.
rodrigo barcatNov 14, 2019 6:56 AM (in response to Rakesh Rajasekar)
1 of 1 people found this helpfulI 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.
-
12. Re: How to remove the inline character to replace with blank.
Sinisa MikorNov 14, 2019 10:24 AM (in response to rodrigo barcat)
Interesting naming convention...
-
13. Re: How to remove the inline character to replace with blank.
rodrigo barcatNov 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?
-
14. Re: How to remove the inline character to replace with blank.
Sinisa MikorNov 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.