Apex Excel 2000
Beverly Friddle
According to what I found on the web this supposed to work, but it doesn't, at least not win Excel 2007 and UTF8 files, Excel treats the 3rd line as the second row of data not as the second line of the first data row.
You should have space characters at the start of fields ONLY where the space characters are part of the data. Excel will not strip off leading spaces. You will get unwanted spaces in your headings and data fields. Worse, the " that should be "protecting" that line-break in the third column will be ignored because it is not at the start of the field.
If you have non-ASCII characters (encoded in UTF-8) in the file, you should have a UTF-8 BOM (3 bytes, hex EF BB BF) at the start of the file. Otherwise Excel will interpret the data according to your locale's default encoding (e.g. cp1252) instead of utf-8, and your non-ASCII characters will be trashed.
It is worth noting that when a .CSV file has fields wrapped in double quotes which contain line breaks, Excel will not import the .CSV file properly if the .CSV file is written in UTF-8 format. Excel treats the line break as if it were CR/LF and begins a new line. The spreadsheet is garbled. That seems to be true even if semi-colons are used as field delimiters (instead of commas).
The problem can be resolved by using Windows Notepad to edit the .CSV file, using File > Save As... to save the file, and before saving the file, changing the file encoding from UTF-8 to ANSI. Once the file is saved in ANSI format, then I find that Microsoft Excel 2013 running on Windows 7 Professional will import the file properly.
This works for me in both Excel 2010 and Excel 2000. However, surprisingly, it works only when you open the file as a new spreadsheet, not when you import it into an existing spreadsheet using the data import feature.
The critical thing is that there is no space after the first ",". Normally spaces are fine, and trimmed if the string is not quoted. But otherwise nasty. Took me a while to figure that out.
putting "\r" at the end of each row actually had the effect of line breaks in excel, but in the .csv it vanished and left an ugly mess where each row was squashed against the next with no space and no line-breaks
Icon is an exclusive conference attended by leaders of best-in-class, global financial shared services, accounts payable, procurement, post-audit and supplier governance, and risk and compliance organizations.
Steve Yurko has served as CEO of apexanalytix since 2009. Since then, he has helped a dedicated team of associates add a record number of new Global 2000 audit and technology clients, expand global capabilities and markets served, launch revolutionary new software solutions and produce more audit recoveries for clients than in any period in company history.
Before becoming CEO, Steve worked closely with apexanalytix clients around the globe as senior vice president of sales and marketing. In that role, he led worldwide sales, product management and branding strategies and drove growth in key commercial, retail, international and technology business segments.
As Chief Operating Officer and Executive Vice President, Global Transaction Compliance Solutions, Phil Beane leads our commercial and retail audit teams and international operations. His focus on customer satisfaction and value creation has helped to fuel a period of double-digit growth.
Phil previously was responsible for leading the apexanalytix audit and software implementation support teams in the Americas. Prior to joining the company, he worked with GMAC Insurance, Questcon Technologies and BCE Emergis, where he specialized in quality assurance consulting and management.
As the Chief Information Officer, Vishal Grover is responsible for establishing and maintaining a company-wide information security and risk management program to ensure that the data assets of apexanalytix and our clients are protected.
Vishal has over 20 years of experience in information technology and has had numerous roles across multiple disciplines such as application development, database management, IT infrastructure and information security. His extensive background includes implementing programs for evolving security and compliance requirements (SSAE18, PCI, secure SDLC, GDPR, disaster recovery) to ensure the highest level of security, performance and availability for the largest companies in the world.
As Chief Human Resources Officer, Jessica Kozak leads our global human resources function at apexanalytix. Her focus includes organization development, integrated talent management, leadership development, and culture.
Jessica is a connective and collaborative leader with human capital strategy and transformation experience. She has been consistently recognized for leading diverse teams, improving performance, and cultivating productivity in highly competitive industries.
Danny has a proven track record in the procure-to-pay arena, with a strong background in ERP implementation, process automation and financial shared services. He previously was vice president of product management at Tungsten Network, a global business-to-business e-invoicing firm. He also is a former global process driver for invoice-to-pay at Pfizer.
Chris Haydon is an innovative operational leader and business strategist with over 20 years of experience in driving revenue and customer adoption through the creation of high-value products, services, and global teams. With a broad background in cloud and enterprise solutions markets, Chris has an exceptional track record in defining strategy and building organizations that excel in execution and customer engagement.
Throughout his career, Chris has demonstrated extensive expertise in procurement, business networks, supply chain, ERP, and cloud subscription and renewal businesses. His previous roles include serving as the President at SAP Procurement Solutions, where he spearheaded initiatives to enhance procurement processes and drive efficiency for businesses. Prior to that, he held the position of Chief Strategy Officer at SAP Ariba, where he played a pivotal role in shaping the strategic direction of one of the leading procurement solutions providers globally.
In addition to his corporate leadership roles, Chris has also made significant contributions as an independent industry consultant, private equity advisor, and board member. His insights and strategic guidance have been sought after by prominent organizations, including KKR, where he provided valuable expertise in driving operational excellence and maximizing returns.
Charles is an experienced and well-regarded senior executive. He co-founded Rosslyn Data Technologies Plc and Darkbeam whilst also serving as an advisor for a number of other successful technology and investment companies.
Alan is passionate about innovation and has a proven track record of identifying new opportunities and leveraging technology to bring innovative products and services to the market. Alan was the founder of Idera Software in 2000 and developed its flagship products. Idera was later acquired by TA Associates in 2014.
Outside of work, Alan likes to participate in technology challenges and competitions. He was awarded as one of the top finalists of the Google Android Challenges in 2008 and 2010 and has worked with Google on its Android operating system and Google App store.
Stephanie brings over 20 years marketing experience. She is a process and revenue marketer with deep experience in tech B2B marketing. She has held leadership positions at high growth tech companies such as TealBook, Dwolla, and Workiva, where she led the strategic Initiative to rename the company from WebFilings. Additionally, Stephanie serves as a Board Director and Treasurer at a $7B financial institution that has pioneered FinTech and FI relations.
As Senior Vice President of Consulting, Jason leads our Presales, Support, and Portal Consulting teams. He is responsible for accelerating time to value for all apexanalytix customers while scaling and growing the portfolio of services that we offer.
Prior to joining the company, he spent more than 16 years at SAP via their 2012 acquisition of Ariba. There, as Global Vice President of Cloud Procurement Services, he was instrumental in the transformation of their 2,000-person services organization and led the integration of Ariba services into SAP in 2020.
In 2014, Geoff joined apexanalytix as the Director of Audit Operations overseeing global recovery audit services across a wide spectrum of industries (pharmaceutical, consumer goods, media, energy, mining and insurance). Prior to joining apexanalytix, Geoff operated as an Audit Principal within the UK grocery and retail sectors overseeing audit strategy, development, delivery and client process enhancement. He has over 25 years of experience within recovery audit and data services management.
Scammers create and maintain fraudulent postings on many reputable job boards, for monetary gain, including Handshake and even networking sites like LinkedIn. While every position that is posted to Handshake is vetted, sometimes fraudulent postings make it through.
Scammers may also directly contact you, for example through email or phone, soliciting to hire you for an open job position. Some will even go as far as stating that they represent an established company or pretend to be a well known individual. They may even reference the ICC in some way to make them seem more legitimate.
These scams most often times target you financially. They may do so directly by asking you to send money to the scammers such as through an online payment application or gift cards. Or they may do so indirectly by stealing your identity or banking information. This may all be done in the disguise of either you getting hired for the job or you performing tasks in the job.
When evaluating an email message, don't rely on just trusting based on who sent it. For example if an email came from an address belonging to your organization, don't automatically assume it is legitimate. Email accounts may become compromised from a scam or phishing attack and end up being used to further scam or phish others within your organzation.
93ddb68554