XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Replacing commas with a blank
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + how to insert un return in the... (2)
-> + String in a range (5)
-> + To identify the right edition (4)
-> + Flow Control Feature (2)
-> + calling nested external functi... (3)
-> - Replacing commas with a blank (6)
-> ->Replacing commas with a b...
-> ->Replacing commas with a b...
-> ->Replacing commas with a b...
-> ->Replacing commas with a b...
-> ->Replacing commas with a b...
-> + Grouping very urgent . (2)
-> + xsl node number (3)
-> + Wordml intelligence (6)
-> + Preview and backmapping for wo... (5)
-> + XSLT - find line numbers of di... (2)
-> + The last five bytes of a varia... (7)
-> + simple problem but i'm a bit t... (3)
-> + H plz help me (2)
-> + XSLT : Very Urgent Requirement (7)
-> + comparing two xml files (3)
-> + Support for xsl created from w... (4)
-> + Wildcard Param (3)
-> + XSLT OutOfMemoryError (3)
-> + How can I output the filename ... (7)
-> + How do I strip out a comma ast... (8)
-> + xslt current-dateTime() not re... (2)
-> + Exceed the maximum recursion d... (8)
-> + Saxon9 "java.net.ConnectExcept... (2)
-> - Help Required (1)
-> + XSLT Help to get value from Up... (2)
-> + Date Functions (5)
-> + Need to unescape < and > (2)
-> + No Topic (2)
-> + Problem with handling multiple... (3)
-> + Question XPath expression (dis... (2)
-> + New user, basic question (2)
-> + Serializing XML to a string wi... (2)
-> + Node already has a control li... (2)
-> + Trying to access the position ... (5)
-> + XSLT Help (2)
-> + XSLT, Microsoft Access, and re... (4)
-> + saxon:assign usage problem. (5)
-> + Help with XSLT mapping require... (4)
-> + Muenchian Grouping problem (6)
-> + Automatic postprocessing (2)
-> + Problem Setting Variable (3)
-> - Problem Setting Variable (1)
-> + Looping question (14)
-> + Attribute Centeric XML from Re... (2)
-> + How do I do this ? (2)
-> + Accessing an attribute based o... (3)
-> + help needed - using saxon thro... (2)
-> + Grouping Problem still (6)
-> + Use XSL-FO to create tables fr... (6)
-> + taking out a child and (6)
-> + Yet another problem (3)
-> + using XSL-FO to convert PDF (4)
-> + Preventing namespace declarati... (2)
-> + Small problem during conversio... (4)
-> + Problems removing namespaces (2)
-> + Grouping/Following question (4)
-> + Transforming XML into another ... (3)
-> + Help Needes (3)
-> - Help needed! (1)
-> + Conv of DSML Format to XML for... (2)
-> - Regd, entering text in the t... (1)
-> + displaying all the text around... (4)
-> + inserting values into empty ta... (5)
-> + How to get rid of xmlns="" att... (3)
-> + XSLT How to include the '<' sy... (2)
-> - HELP: Functional XSLT Implemen... (1)
-> - Cannot find a matching 1-argum... (1)
-> + XSLT a:? (2)
-> + Attribute Value Concatenation (2)
-> - Why is the WYSIWYG xslt editor... (1)
-> + WebService Call Error: Ref ele... (4)
-> + How to replace value of a fiel... (2)
-> + Schema Validation Problems (3)
-> + Reusing a prior valid value in... (5)
-> + Clutching at straws! (2)
-> + Adding a number to a for each ... (2)
-> + Transform Name Value pairs int... (4)
-> + Transform the XML Scheme with ... (2)
-> + create XML drop down lists (2)
-> + error during stylesheet tutori... (3)
-> + Modify the value in a element ... (2)
-> + Call to extension function fai... (2)
-> + Convert XML Schema to XML - Mi... (2)
-> + How to calculate maximun RowCo... (3)
-> + Help with using not(preceding:... (5)
-> - Please Help me on this XML to ... (1)
-> + Paasing Parameter Values From ... (6)
-> + XSLT Transformation w/ namespa... (3)
-> + For-each select and parameter ... (3)
-> + Using < (less than) operator (5)
-> + Inserting carriage return (spe... (3)
-> + Inserting carriage return (spe... (2)
-> + Help with SerializerTrace erro... (8)
-> + xml to x3d (5)
-> + Exiting processing loop early (2)
-> + Easy way to Convert One source... (3)
-> + XSLT Editor tab missing from D... (2)
-> + Writing strings of characters ... (4)
-> + Adding the content of an eleme... (3)
-- Previous [601-620] [621-640] [641-660] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Maurice GonsalvesSubject: Replacing commas with a blank
Author: Maurice Gonsalves
Date: 28 May 2008 03:33 PM


Hi! I'm new in XSLT. I need to search an IDOC field (e.g. E1KNA1M-NAME1) for commas and replace them with a blank.
I have the Syntax, "xsl:value-of select="translate(E1KNA1M/NAME1,',',' ')"/>
my problem is where do I use it in the program below...
if someone can help, it'll be great!!


<xsl:for-each select="ns:Messages/child::*">
<xsl:for-each select="Z1SD_EXT_DEBMAS_US/IDOC/E1KNA1M/Z1Z1SD_US_E1KNA1M_EXT">

<xsl:variable name="vtweg">
<xsl:value-of select="concat(VTWEG, VKORG, KVGR3)"/>
</xsl:variable>

<Record>
<xsl:for-each select="parent::E1KNA1M">
<CUSTOMER>
<xsl:value-of select="KUNNR"/>
</CUSTOMER>
</xsl:for-each>
<DIST_CHANNEL>
<xsl:value-of select="VTWEG"/>
</DIST_CHANNEL>
<xsl:for-each select="parent::E1KNA1M">
<NAME1>
<xsl:value-of select="NAME1"/>
</NAME1>
<NAME2>
<xsl:value-of select="NAME2"/>
</NAME2>
<ADDRESS1>
<xsl:value-of select="STRAS"/>
</ADDRESS1>
</xsl:for-each>
Postnext
Maurice GonsalvesSubject: Replacing commas with a blank
Author: Maurice Gonsalves
Date: 28 May 2008 03:34 PM
I meant the location of the coding...
Postnext
(Deleted User) Subject: Replacing commas with a blank
Author: (Deleted User)
Date: 29 May 2008 12:42 PM
You should use it where you access the NAME1 element...

<NAME1>
<xsl:value-of select="translate(NAME1,',',' ')"/>
</NAME1>

Alberto
Postnext
Maurice GonsalvesSubject: Replacing commas with a blank
Author: Maurice Gonsalves
Date: 04 Jun 2008 10:27 AM


Thanks Albert for the reply!

I'm using the mapping to create all the fields (KUNNR, VTEG, NAME1 etc.) first!
Then I would like to replace the commas in each fields with Blanks.

You think I should use the codes like this...for example for Field, "NAME1"

<NAME1>
<xsl:value-of select="NAME1"/>
<xsl:value-of select="translate(NAME1,',',' ')"/>
</NAME1>

?? Please advise if possible...
Postnext
(Deleted User) Subject: Replacing commas with a blank
Author: (Deleted User)
Date: 04 Jun 2008 12:36 PM
Originally Posted: 04 Jun 2008 12:35 PM
Hi Maurice,
you can first use Mapper to create the structure, and then later replace the NAME1 inside the "select" attribute with the "translate(...)" operation (if you keep both instructions, you will get the same string twice in the output); or you could let Mapper build the function by inserting the block for the "translate" function in the canvas, connect the source NAME1 element to its first input, enter "," and " " as the values for the second and third input port, then link the output to the desired target element. Clearly, if you are doing this many times, it's probably faster to do it just once and then replicate the editing in the text view.

Hope this helps,
Alberto
Posttop
Maurice GonsalvesSubject: Replacing commas with a blank
Author: Maurice Gonsalves
Date: 05 Jun 2008 11:03 AM

Thanks very much for your help!!

I have 2 more requests...if you can shed some light, that'll be great help!
I'm putting the first one this time.


I have a document where I have several segments of E1KNVKM and within the segments I have
fields (NAME1, NAMEV & ABTNR) like below:

E1KNVKM

=>NAME1=X
=>NAMEV=Y
=>ABTNR=0000


E1KNVKM

=>NAME1=X
=>NAMEV=Y
=>ABTNR=5678


E1KNVKM

=>NAME1=X
=>NAMEV=Y
=>ABTNR=9999


E1KNVKM

=>NAME1=X
=>NAMEV=Y
=>ABTNR=5898

and so on
.
.
.


Now, I want to write the value "X" for NAME1 and "Y" for NAMEV
if and only if ABTNR=9999
Otherwise, insert a "comma" instead of "X" & "Y"


for the 4 checks the output would look like

,
,


X
Y


,







I start with the XSL codes below, but I'm not sure how I am going to write the conditions and necessary
steps...




<xsl:for-each select="E1KNVKM">


<NAME1>
<xsl:value-of select="NAME1"/>
</NAME1>

<NAMEV>
<xsl:value-of select="NAMEV"/>
</NAMEV>






</xsl:for-each>
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.