9 Replies Latest reply: May 15, 2014 9:58 AM by JoeBowlin _ RSS

    Special Characters Instead of Spaces In Text File

    JoeBowlin _

      A client recently "upgraded" his software. He has sent me new flat text files to process into Excel pivot tables but many of the blank spaces are are now filled with the special character "á". When I open these files with Wordpad, the blank spaces appear to be blank spaces. I cannot now extract the information with Monarch.

       

      Below is a page of the new data as cut and pasted from Monarch. Incidentally, if I open the file with Wordpad, then cut and paste, everything appears fine.

                                                                                      xxxxxxx Country Club                                                                               

      Departmental Income Statement - September, 2007                                                                               

      02 - Dining Room                                                                               

      áááááááááááááááááááááááááááááááááááááááááááááThisáááááThisáMtháááThisáMontháááááááááYearááááááááááYTDááááááááááYTD  

      ááááááááááááááááááááááááááááááááááááááááááááMontháááááááBudgetááááLastáYearááááááToáDateáááááááBudgetááááááLastáYr                                                                               

      áááááááááááSales                                                                               

      ááááááááááááFoodáIncomeááááááááááááááááááááá7,464ááááááá10,000áááááááá7,903ááááááá69,610ááááááá98,300ááááááá89,584  

      ááááááááááááEmployeeáFoodáIncomeáááááááááááááá464áááááááááá700áááááááááá635áááááááá5,983áááááááá5,950áááááááá5,757  

      ááááááááááááLiquoráIncomeááááááááááááááááááááá441áááááááááá325áááááááááá312áááááááá3,628áááááááá4,055áááááááá4,092  

      ááááááááááááBeeráIncomeááááááááááááááááááááááá135áááááááááá125áááááááááá114áááááááá1,070áááááááá1,435áááááááá1,401  

      ááááááááááááWineáIncomeááááááááááááááááááááááá491áááááááááá800áááááááááá830áááááááá4,523áááááááá6,150áááááááá6,380  

      áááááááááááááááááááááááááááááááááááááá--


      áá
      áá

      áá

      áá

      áá
      --


          

      áááááááááááTotaláSalesáááááááááááááááááááááá8,994ááááááá11,950áááááááá9,793ááááááá84,813áááááá115,890áááááá107,214                                                                               

      áááááááááááCostáofáGoodsáSold                                                                               

      ááááááááááááFoodá-áCostáofáSalesáááááááááááá4,303áááááááá4,700ááááááá12,862ááááááá45,425ááááááá46,201ááááááá66,180  

      ááááááááááááFoodáCompá-áCostáofáSaleááááááááááá29áááááááááá100ááááááááááá28áááááááááá234áááááááááá900áááááááááá837  

      ááááááááááááLiquorá-áCostáofáSalesáááááááááááá101ááááááááááá72ááááááááááá72áááááááááá835áááááááááá892áááááááááá942  

      ááááááááááááBeerá-áCostáofáSalesááááááááááááááá45ááááááááááá41ááááááááááá38áááááááááá353áááááááááá474áááááááááá462  

      ááááááááááááWineá-áCostáofáSalesáááááááááááááá172áááááááááá256áááááááááá291áááááááá1,583áááááááá1,968áááááááá2,233  

      áááááááááááááááááááááááááááááááááááááá--


      áá
      áá

      áá

      áá

      áá
      --


          

      áááááááááááTotaláCostáofáGoodsáSoldááááááááá4,650áááááááá5,169ááááááá13,290ááááááá48,430ááááááá50,435ááááááá70,654                                                                               

      áááááááááááááááááááááááááááááááááááááá--


      áá
      áá

      áá

      áá

      áá
      --


          

      áááááááááááGrossáProfitááááááááááááááááááááá4,344áááááááá6,781ááááááá-3,497ááááááá36,383ááááááá65,455ááááááá36,560                                                                               

      áááááááááááOtheráIncome                                                                               

      ááááááááááááServiceáChargeáááááááááááááááááá1,760áááááááá2,390áááááááá1,959ááááááá15,986ááááááá23,178ááááááá20,087  

      ááááááááááááFoodáMinimumáááááááááááááááááááááá477áááááááááá500áááááááááá439ááááááá12,581áááááááá7,300ááááááá10,123  

      áááááááááááááááááááááááááááááááááááááá--


      áá
      áá

      áá

      áá

      áá
      --


          

      áááááááááááTotaláOtheráIncomeááááááááááááááá2,237áááááááá2,890áááááááá2,398ááááááá28,567ááááááá30,478ááááááá30,210                                                                               

      áááááááááááááááááááááááááááááááááááááá--


      áá
      áá

      áá

      áá

      áá
      --


          

      áááááááááááTotaláIncomeááááááááááááááááááááá6,581áááááááá9,671ááááááá-1,099ááááááá64,951ááááááá95,933ááááááá66,770                                                                               

      áááááááááááExpenses                                                                               

      ááááááááááááSalariesá-áManageráááááááááááááá4,583áááááááá4,584áááááááá3,801ááááááá41,249ááááááá41,256ááááááá31,751  

      ááááááááááááSalariesáááááááááááááááááááááááá5,440áááááááá4,500áááááááá4,333ááááááá47,656ááááááá40,800ááááááá39,274  

      ááááááááááááSalariesá-áKitchenááááááááááááá11,211ááááááá10,088áááááááá8,630áááááá106,516ááááááá90,792ááááááá87,338  

      ááááááááááááPayrolláTaxesááááááááááááááááááá2,375áááááááá1,923áááááááá1,867ááááááá17,460ááááááá17,217ááááááá15,546  

      ááááááááááááHospitalizationáInsurancáááááááá1,101áááááááá1,800áááááááá1,360ááááááá13,040ááááááá16,200ááááááá16,450  

      ááááááááááááWorkers'áCompensationáInáááááááá1,024áááááááááá525áááááááááá739áááááááá6,704áááááááá4,725áááááááá4,723  

      ááááááááááááRepairsá-áEquipmentáááááááááááááááá84áááááááááá900áááááááááá808áááááááá8,642áááááááá8,100áááááááá8,012  

      ááááááááááááRepairsá-áBuildingáááááááááááááááá882áááááááááá550áááááááááá457áááááááá1,338áááááááá4,950áááááááá4,526  

      ááááááááááááSuppliesáááááááááááááááááááááááááá909áááááááá2,200áááááááá2,221ááááááá17,878ááááááá20,900ááááááá20,242  

      ááááááááááááLaundryá&áLinenááááááááááááááááááá318áááááááááá500áááááááááá536áááááááá4,405áááááááá4,500áááááááá4,999  

      ááááááááááááChinaá&áFlatwareáááááááááááááááááááá0áááááááááá200áááááááááááá0áááááááááááá0áááááááá1,800áááááááá1,048

        • Special Characters Instead of Spaces In Text File
          Grant Perkins

          Hi Joe and welcome to the forum.

           

          I'm going to guess that the 'upgrade' has introduced a different way of handling the character set produced by the reports/

           

          In V8 you have some OPTIONS that you can set that will interpret the INPUT file differently. (With V9 you have yet more). I would try the different settings first to see if that solves the problem - maybe the client can help by advising the technical differences between their old and new system.

           

          If that does not produce a usable result we need to consider other options. So let us know one way or the other and we can continue with other ideas if needed.

           

          HTH.

           

           

          Grant

          • Special Characters Instead of Spaces In Text File
            joey

            From what you sent, it appears to me that he is sending you the ascii value 255 instead of ascii 32.  I think you should be able to use the MSRP to fix this.

             

            [font="courier"] msrp "/255" " " file.txt /font[/quote]

            • Special Characters Instead of Spaces In Text File
              Data Kruncher

              I think the ASCII value that Joey meant was 225 instead of 255.

               

              Joey?

              • Special Characters Instead of Spaces In Text File
                joey

                You're absolutely right.  Good catch!

                • Special Characters Instead of Spaces In Text File
                  Grant Perkins

                  If MSRP is not installed for you try the Monarch Utility for any character exchanges you may require  - the MSRP functionality suggested is also available there.

                   

                  Have you also tried simply opening the file with workpad and then saving it as a new file? Does that also make the conversion?

                   

                  Grant

                  • Special Characters Instead of Spaces In Text File
                    JoeBowlin _

                    Thanks for all the suggestions. Yes, I tried opening and saving with Wordpad and it had no effect.

                     

                    I tried various input options and ANSI appeared to work but when I opened the model the "á" characters reappeared.

                     

                    I tried Monarch Utility using the character to be replaced as 255, 225 and 160 to be replaced by 32. Below is the message I received:

                     

                    Prepare files for Monarch

                     

                    Type: replacing "á" with " "

                     

                    Source file(s): Copy of Deptartmental Statement sept 2007.txt

                    Source folder: C:Documents and SettingsJoe BowlinDesktop

                     

                    Destination file: Copy of Deptartmental Statement sept 2007.txt

                    Destination folder: C:Documents and SettingsJoe BowlinDesktop

                     

                    Press "Finish" to execute this task.

                     

                    Prepare files for Monarch

                     

                    Type: replacing "á" with " "

                     

                    - <log operation="Prepare files for Monarch">

                      <status type="Failure" />

                    - <status type="Success">

                      <file src="C:Documents and SettingsJoe BowlinDesktopCopy of Deptartmental Statement sept 2007.txt" dest="C:Documents and SettingsJoe BowlinDesktopCopy of Deptartmental Statement sept 2007.txt" />

                      </status>

                      </log>

                    • Special Characters Instead of Spaces In Text File
                      Data Kruncher

                      When specifying the Replace field value use

                      [font="courier"]/225  /font[/quote]and supply

                       

                      [font="courier"]/032  /font[/quote]with the leading slashes. Also, if there's an option, set the character set to ASCII.

                       

                      This works for me. I copied and pasted your sample into a .txt file, and ran it through the Utility just fine.

                      • Special Characters Instead of Spaces In Text File
                        JoeBowlin _

                        Maybe I just don't understand how to use Utility. Here is what I did and the result:

                         

                        Prepare files for Monarch

                         

                        Type: replacing "/225" with "/032"

                         

                        Source file(s): Copy of Deptartmental Statement sept 2007.txt

                        Source folder: C:Documents and SettingsJoe BowlinDesktop

                         

                        Destination file: Copy of Deptartmental Statement sept 2007.txt

                        Destination folder: C:Documents and SettingsJoe BowlinDesktop

                         

                        Press "Finish" to execute this task.

                        -


                        - <log operation="Prepare files for Monarch">

                          <status type="Failure" />

                        - <status type="Success">

                          <file src="C:Documents and SettingsJoe BowlinDesktopCopy of Deptartmental Statement sept 2007.txt" dest="C:Documents and SettingsJoe BowlinDesktopCopy of Deptartmental Statement sept 2007.txt" />

                          </status>

                          </log>

                        • Special Characters Instead of Spaces In Text File
                          JoeBowlin _

                          I got it! I ran Utility replacing /160 with /032 and everything works including the text field matching lookups.

                           

                          Thanks much,

                           

                          Joe Bowlin